package com.ant.storage.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

/**
 * @author hzd
 * @version 1.0
 * @date 2024/7/24 8:37
 */
@Data
public class HouseLeaseExcel {

    @ExcelProperty(value = "城市", index = 0)
    @ColumnWidth(12)
    private String cityId;

    @ExcelProperty(value = "公司", index = 1)
    private String companyId;

    @ExcelProperty(value = "合同类型", index = 2)
    private String contractType;

    @ExcelProperty(value = "合同编号", index = 3)
    private String contractNumber;

    @ExcelProperty(value = "合同名称", index = 4)
    private String contractName;

    @ExcelProperty(value = "地址", index = 5)
    private String address;

    @ExcelProperty(value = "面积", index = 7)
    private String area;

    @ExcelProperty(value = "租金", index = 8)
    private String amount;

    @ExcelProperty(value = "押金", index = 9)
    private String deposit;

    @ExcelProperty(value = "结余房租", index = 10)
    private String surplusRent;

    @ExcelProperty(value ="开始时间", index = 11)
    private String startTime;

    @ExcelProperty(value = "截止时间", index = 12)
    private String deadline;

    @ExcelProperty(value = "费用到期时间", index = 13)
    private String feeDue;

    @ExcelProperty(value = "支付方式", index = 14)
    private String paymentMethod;

    @ExcelProperty(value = "合同状态", index = 15)
    private String contractStatus;

    @ExcelProperty(value = "备注", index = 16)
    private String notes;

    @ExcelProperty(value = "经办人", index = 17)
    private String founder;

    @ExcelProperty(value = "签订时间", index = 18)
    private String signingTime;

    @ExcelProperty(value = "是否生效 0 不 1 生效", index = 19)
    private String takeEffect;

    @ExcelProperty(value ="电费/度", index = 20)
    private String electricCharge;

    @ExcelProperty(value = "水费/度", index = 21)
    private String waterRate;

    @ExcelProperty(value = "气费/度", index = 22)
    private String gasBill;

    @ExcelProperty(value = "物业/元", index = 23)
    private String property;

    @ExcelProperty(value = "递增比例", index = 24)
    private String increase;

    @ExcelProperty(value = "创建人", index = 25)
    private String createBy;

    @ExcelProperty(value = "创建时间", index = 26)
    private String creationTime;

}
